Tabela ArchiveDocOrderItem

Definicja tabeli ArchiveDocOrderItem

Name

ArchiveDocOrderItem

Code

ArchiveDocOrderItem

Comment

 


Lista kolumn tabeli ArchiveDocOrderItem

Name

Code

ArchiveDocOrderItemID

ArchiveDocOrderItemID

ArchiveDocID

ArchiveDocID

ArchiveDocOrderID

ArchiveDocOrderID

ArchiveDocStatusID

ArchiveDocStatusID

OrderPurposeID

OrderPurposeID

ArchiveDocRealizationStatusID

ArchiveDocRealizationStatusID

LendLocID

LendLocID

SuggestedStopDT

SuggestedStopDT

OriginalGiven

OriginalGiven

LendDT

LendDT

LendUser

LendUser

LendComments

LendComments

ReturnDT

ReturnDT

ReturnUser

ReturnUser

ReturnComments

ReturnComments

CancelDT

CancelDT

CancelUser

CancelUser

CancelComments

CancelComments

TakingPerson

TakingPerson

ReturnPerson

ReturnPerson


Kolumna ArchiveDocOrderItemID tabeli ArchiveDocOrderItem

Definicja kolumny ArchiveDocOrderItemID tabeli ArchiveDocOrderItem

Name

ArchiveDocOrderItemID

Code

ArchiveDocOrderItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ArchiveDocID tabeli ArchiveDocOrderItem

Definicja kolumny ArchiveDocID tabeli ArchiveDocOrderItem

Name

ArchiveDocID

Code

ArchiveDocID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ArchiveDocOrderID tabeli ArchiveDocOrderItem

Definicja kolumny ArchiveDocOrderID tabeli ArchiveDocOrderItem

Name

ArchiveDocOrderID

Code

ArchiveDocOrderID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ArchiveDocStatusID tabeli ArchiveDocOrderItem

Definicja kolumny ArchiveDocStatusID tabeli ArchiveDocOrderItem

Name

ArchiveDocStatusID

Code

ArchiveDocStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna OrderPurposeID tabeli ArchiveDocOrderItem

Definicja kolumny OrderPurposeID tabeli ArchiveDocOrderItem

Name

OrderPurposeID

Code

OrderPurposeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ArchiveDocRealizationStatusID tabeli ArchiveDocOrderItem

Definicja kolumny ArchiveDocRealizationStatusID tabeli ArchiveDocOrderItem

Name

ArchiveDocRealizationStatusID

Code

ArchiveDocRealizationStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

Status realizacji zamówienia


Kolumna LendLocID tabeli ArchiveDocOrderItem

Definicja kolumny LendLocID tabeli ArchiveDocOrderItem

Name

LendLocID

Code

LendLocID

Data Type

NUMBER(10)

Mandatory

No

Comment

Komórka, która wydala dokumentacje medyczna


Kolumna SuggestedStopDT tabeli ArchiveDocOrderItem

Definicja kolumny SuggestedStopDT tabeli ArchiveDocOrderItem

Name

SuggestedStopDT

Code

SuggestedStopDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna OriginalGiven tabeli ArchiveDocOrderItem

Definicja kolumny OriginalGiven tabeli ArchiveDocOrderItem

Name

OriginalGiven

Code

OriginalGiven

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna LendDT tabeli ArchiveDocOrderItem

Definicja kolumny LendDT tabeli ArchiveDocOrderItem

Name

LendDT

Code

LendDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna LendUser tabeli ArchiveDocOrderItem

Definicja kolumny LendUser tabeli ArchiveDocOrderItem

Name

LendUser

Code

LendUser

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LendComments tabeli ArchiveDocOrderItem

Definicja kolumny LendComments tabeli ArchiveDocOrderItem

Name

LendComments

Code

LendComments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ReturnDT tabeli ArchiveDocOrderItem

Definicja kolumny ReturnDT tabeli ArchiveDocOrderItem

Name

ReturnDT

Code

ReturnDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ReturnUser tabeli ArchiveDocOrderItem

Definicja kolumny ReturnUser tabeli ArchiveDocOrderItem

Name

ReturnUser

Code

ReturnUser

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ReturnComments tabeli ArchiveDocOrderItem

Definicja kolumny ReturnComments tabeli ArchiveDocOrderItem

Name

ReturnComments

Code

ReturnComments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna CancelDT tabeli ArchiveDocOrderItem

Definicja kolumny CancelDT tabeli ArchiveDocOrderItem

Name

CancelDT

Code

CancelDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna CancelUser tabeli ArchiveDocOrderItem

Definicja kolumny CancelUser tabeli ArchiveDocOrderItem

Name

CancelUser

Code

CancelUser

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CancelComments tabeli ArchiveDocOrderItem

Definicja kolumny CancelComments tabeli ArchiveDocOrderItem

Name

CancelComments

Code

CancelComments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna TakingPerson tabeli ArchiveDocOrderItem

Definicja kolumny TakingPerson tabeli ArchiveDocOrderItem

Name

TakingPerson

Code

TakingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ReturnPerson tabeli ArchiveDocOrderItem

Definicja kolumny ReturnPerson tabeli ArchiveDocOrderItem

Name

ReturnPerson

Code

ReturnPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli ArchiveDocOrderItem

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ArchiveDocOrderItem

Definicja klucza Identifier_1 tabeli ArchiveDocOrderItem

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment